https://store-images.s-microsoft.com/image/apps.35746.8a3d9cc7-24c1-4a84-b03f-260b3ca6054f.ffd01ba9-9eab-451f-89b3-c2627d5633eb.fa191be1-2b65-4c7b-88eb-dad3428abb85

BI Endpoints

by Datawareness ApS

Free trial badge

Simplified API endpoints for extracting Business Central data into fx. Power BI and Microsoft Fabric

Datawareness BI Endpoints - Streamlined Data Access for Business Intelligence
Datawareness BI Endpoints is an extension that provides a comprehensive set of pre-built API endpoints designed specifically for business intelligence and analytics workloads. Start building dashboards and data pipelines in minutes.

Why this application?
Extracting data from Business Central for reporting and analytics traditionally requires deep knowledge of the underlying table structures, relationships, and query syntax. This application eliminates this complexity by providing ready-to-use API pages that expose your business data in a clean, consistent format.

Getting started
Download our comprehensive Reference Guide for detailed setup instructions, endpoint documentation, and integration examples.
Get access to sample code and detailed endpoint reference guide in Business Central after installing the application.

Use it for
- Microsoft Power BI - Connect directly to Business Central with OAuth authentication
- Microsoft Fabric Lakehouses - Load data using Spark notebooks with built-in incremental extraction support
- Data Warehouses - Use as a standardized source for your enterprise data platform
- Custom Integrations - Access clean, well-documented APIs for any analytics tool

Key Features
- Optimized for BI - Endpoints are designed for reporting, not transactional operations
- Incremental Support - Built-in systemModifiedAt timestamps enable efficient delta loading
- Consistent Structure - All endpoints follow the same patterns and conventions
- Comprehensive Documentation - Full reference guide with setup instructions and examples

Subscription options
- Free: Posted sales invoices and posted G/L entries for basic reporting purposes.
- Premium: 14 days free trial. Extensive data access for advanced reporting. Finance, Sales, Purchasing, Inventory, Jobs and Resources.

Which endpoints are included?
Finance
- General Ledger Entries with full dimension support
- Chart of Accounts and G/L Account Categories
- General Ledger Budget Entries

Sales
- Customers and Customer Ledger Entries
- Posted Sales Invoices
- Posted Sales Credit Memos
- Sales Documents (quotes, orders, etc.)

Purchasing
- Vendors and Vendor Ledger Entries
- Posted Purchase Invoices and Credit Memos
- Purchase Documents (quotes, orders, etc.)

Inventory
- Items
- Item Value Entries

Projects
- Jobs
- Job Ledger Entries

Resources
- Employees, Users and Resources
- Capacity Entries
- Time Sheets

At a glance

https://store-images.s-microsoft.com/image/apps.36961.8a3d9cc7-24c1-4a84-b03f-260b3ca6054f.ffd01ba9-9eab-451f-89b3-c2627d5633eb.5cd40278-7e56-49a0-826b-49070067fc81
https://store-images.s-microsoft.com/image/apps.11185.8a3d9cc7-24c1-4a84-b03f-260b3ca6054f.ffd01ba9-9eab-451f-89b3-c2627d5633eb.325892cb-ddd8-4fe9-9394-115e3d24614d
https://store-images.s-microsoft.com/image/apps.3414.8a3d9cc7-24c1-4a84-b03f-260b3ca6054f.ffd01ba9-9eab-451f-89b3-c2627d5633eb.f345ff9c-2d16-4762-bff6-bbb6e8dfc4ac
https://store-images.s-microsoft.com/image/apps.31932.8a3d9cc7-24c1-4a84-b03f-260b3ca6054f.ffd01ba9-9eab-451f-89b3-c2627d5633eb.bc272ebc-d545-42b1-9b4a-e945db6384b1
https://store-images.s-microsoft.com/image/apps.46577.8a3d9cc7-24c1-4a84-b03f-260b3ca6054f.ffd01ba9-9eab-451f-89b3-c2627d5633eb.e264e427-9b32-4ef2-af19-dabdaa82c8cc